SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482272 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482272 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312161,434676,105953,173628,154606,118344,171211,599021,446421,309017,969102,758677,545848,286689,307201,236695,427970,362915,425454,82,591894,945917,25068,956112,675001,1032900,21757,633758,649407,1038099,500781,276333,597529,508620,1024153,859764,690730,646017,1032806,606677,543134,224603,871469,556403,668567,802511,160829,492101,377653,138547,18375,7411,467545,640030,1021806,895505,738207,618846,10414,430856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]