SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021323 LIMIT 1 [ RunTime:0.003341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021323 [ RunTime:0.005995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810249,374462,196633,449010,369451,30978,362582,545994,1011006,404830,13914,625408,599368,246348,115768,705753,782580,252567,195677,977100,716527,883184,797485,332543,189393,406303,955607,1002201,385785,343610,847800,967201,626393,701254,1026589,751966,935904,991299,222811,536843,136965,96284,125351,942774,331071,97595,605629,48093,1038414,305524,424065,731804,10961,37113,799611,895594,62118,182370,479105,474721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]