SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017190 LIMIT 1 [ RunTime:0.001536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017190 [ RunTime:0.004757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582633,137285,592540,461606,167215,660151,537445,277061,926013,404369,573946,279983,837413,106284,615004,510926,809439,237027,910400,260415,436463,598157,589862,935027,295709,1011046,969816,1010480,925688,307140,108300,749471,815596,391412,798464,266230,628167,42561,237729,718841,146719,774142,71350,455197,74013,136177,925539,172629,726481,874015,706266,194627,711516,993590,273766,828328,863429,832939,738107,142110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001462s ]