SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001573s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499574 LIMIT 1 [ RunTime:0.000730s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499574 [ RunTime:0.004286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518773,537343,931719,972900,480385,719813,338405,983413,668115,139760,488713,565031,156868,122381,943445,156514,560900,171830,792262,509415,14461,974699,606375,935659,624897,973694,27740,46961,359950,494003,185148,706553,10729,214467,658639,502156,89315,722082,896069,178542,73552,171360,834303,137980,412577,229978,169753,368662,316777,448076,25924,153218,100131,551941,175371,481636,818361,603992,842490,380217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499574 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499574 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]