SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104988 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104988 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5468,765688,446421,767773,99984,800651,431619,327997,705612,935643,930806,361577,679828,920061,237494,301545,437926,199407,1018010,87314,535010,412966,812328,515960,59024,809696,648917,70406,393190,367851,438064,190755,366644,462960,753556,22689,885892,304584,143588,135440,368543,81272,773064,332645,501543,93367,222044,481422,858698,98812,717098,833155,294602,165523,539733,709562,120912,457024,331777,492341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]