SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505235 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505235 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516592,480337,753075,361001,218794,971586,488157,889198,1026129,63715,138762,406101,221661,102153,663600,169705,612974,743800,673303,692429,37175,415658,375159,43344,755706,405872,197442,165659,13171,416492,773318,784998,762515,509911,611571,36480,644725,950414,798087,368959,141084,625297,503786,204025,326984,581972,384138,999670,718370,958628,428371,273076,230737,144737,636176,994006,331882,634928,1023720,460997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505235 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505235 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]