SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043654 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043654 [ RunTime:0.002278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198264,858001,174855,286725,272906,366889,186617,760667,96037,305564,7417,585903,1048431,1019770,919217,665897,93829,113403,505994,267264,290796,581324,666051,144385,864334,356253,549363,835373,1018196,702758,88394,39287,296331,335730,1036426,464825,617781,664656,693183,355166,83535,204594,1031925,453889,636631,129502,502887,811171,141510,727304,540033,321119,293059,271995,1040338,32638,439973,273479,345663,306893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]