SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407640 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407640 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914142,143372,54110,1012647,11547,1001346,711082,965473,1007356,927025,328415,937365,951950,283575,503842,49920,117888,782590,338062,165012,383156,993889,985165,47546,650030,355897,620059,302787,145198,1038007,850618,564750,208003,360578,939387,207328,155790,165272,200259,5987,786485,605850,479796,346918,168996,40276,175961,569801,503891,531417,328887,926615,108217,242387,711314,270223,257834,848349,63834,936069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]