SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 621001 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 621001 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89899,1013610,400552,143506,886638,411406,657058,567130,264842,54171,25631,159881,830876,865111,1000892,463356,279129,145586,78807,651778,610281,749405,743365,755821,656168,976174,147065,812692,434365,402495,527748,421807,71816,395932,670158,834794,191388,78514,436937,1026245,278583,159536,775267,421759,621134,4228,784393,60830,60411,377576,946953,57542,399186,494996,898898,622175,567394,679396,657436,872116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 621001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 621001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]