SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550342 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550342 [ RunTime:0.001959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459909,751905,450233,68983,938790,857581,456009,146942,388194,546680,520372,987066,114581,255675,1045648,466664,666280,11381,155554,302441,407651,573927,544596,729931,325518,160198,263677,985514,958933,478783,701029,252743,412372,367261,937603,8531,344160,730482,993661,944979,41017,1027415,732994,725684,501112,382721,807384,97956,604309,331074,772811,561396,350843,1007045,286687,161955,357751,347518,641005,43040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550342 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550342 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001986s ]