SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503419 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503419 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421552,777923,566175,755142,567099,948831,134001,607123,567982,729130,920904,925077,776106,641843,931299,266293,910867,788457,602464,467110,684344,992494,866231,693026,890945,420857,683702,802567,167868,420016,750070,324288,495553,829974,569569,752357,951439,6321,200893,318559,227076,517365,888395,648176,100590,116661,882104,95612,262533,8288,425002,508735,190404,233026,769796,622433,655028,711673,458969,374418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]