SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319084 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319084 [ RunTime:0.002073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160548,128274,1031670,286910,551442,858814,50039,535433,464695,409980,57250,566775,583362,882004,430830,815488,85966,998457,952604,798857,487243,1048827,821348,669424,938985,391603,421862,940032,218135,796120,921340,232393,654502,415201,900092,192169,689780,915666,1001624,424711,509666,154403,760589,495498,933410,583677,191868,925580,67938,908151,612328,985004,433414,125638,835105,296294,990367,483482,841038,683947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]