SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002041s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 922810 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 922810 [ RunTime:0.002684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037629,526982,773413,311636,868668,918302,121317,193648,268919,202199,522650,528021,603521,805282,701975,782728,544089,958700,198107,415794,624860,702850,188018,287706,238009,171101,342546,461953,729910,519769,694866,1028912,754617,673333,958178,737198,544209,499194,216280,931467,904456,529883,508982,711909,346699,463414,45829,573311,765626,437796,1021274,559003,735557,1031061,913670,691355,699239,53463,989962,15727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 922810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 922810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000741s ]