SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016470 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016470 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401191,2814,754719,927094,920722,944438,262618,430838,268248,38888,478848,225494,1023708,285018,943257,1013122,261704,769260,824300,229868,514764,557045,1015426,409077,575176,233814,1045581,321207,195842,254900,444812,839560,974498,441296,424637,406415,861489,71810,703434,864258,383136,529076,649998,713383,645734,119191,367933,362408,149448,502654,137879,365480,468280,233991,883585,109791,135962,955822,675022,213713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]