SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334060 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334060 [ RunTime:0.002659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308321,73643,352218,23780,492243,610040,921402,775340,31674,157391,217937,682135,646362,91743,663361,154316,580259,704642,7159,907277,67072,446365,989907,314290,634878,467228,436589,503625,295719,471954,656746,624800,3726,768344,838237,750860,693105,51083,968602,446505,58058,478118,1021980,765559,826837,631699,245811,1021170,55055,966058,991614,796899,850363,750216,897744,1019810,572666,220221,512344,1012208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002224s ]