SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045309 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045309 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42679,232697,597471,834927,862525,867941,637954,40673,107421,522818,413978,601730,972118,908255,686686,204643,263377,653310,1002349,829078,336472,481673,513591,129556,299330,319620,484918,912650,562874,218247,641807,756948,185429,692766,477374,358351,335850,889882,46172,489936,835784,512298,371901,1013361,113906,517202,856209,1018733,981318,137043,591625,262175,80912,458391,45985,501053,216942,965884,1036776,389490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]