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` = 584511 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584511 [ RunTime:0.002963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (823023,940669,271702,416913,281213,1044708,410962,344157,242665,772859,179436,592354,48990,374722,464868,413377,1026807,257593,38654,760944,996922,264642,22978,487516,550726,945125,558191,378969,652354,955476,1032685,996670,1034270,639554,167919,1008534,355165,882580,110301,888806,710730,352957,154621,992544,633089,331287,953621,236231,820764,531468,211405,989122,876205,585468,639796,966424,815244,625822,500174,898954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]