SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254118 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254118 [ RunTime:0.002500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027701,242525,788210,431101,1004247,705943,68427,269105,762552,166528,801179,975350,495248,645533,62357,186111,686106,879965,610309,352898,987419,834718,901133,695259,509712,550179,205656,359395,139957,784538,639758,763968,822849,90736,155036,1043667,334936,398020,347413,366106,297580,1043734,968004,665383,344306,836984,471876,718810,887743,93877,631307,26203,867081,790933,173366,331601,124600,78761,1046443,891906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]