SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545579 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545579 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764118,695769,50693,125563,1044402,728479,406982,540463,518726,838002,155471,844965,907020,131412,680473,555596,330650,279419,505044,529682,460395,815825,857215,225815,404879,349887,452040,385888,849816,1004228,1044654,132672,756422,951096,457779,506688,168806,649419,782009,511803,1026249,908879,119556,9960,678709,696337,531421,581637,983116,778062,745606,457026,454317,972321,361864,125815,834919,895300,770814,374035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545579 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545579 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]