SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457414 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457414 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369146,720884,685016,132165,30348,630935,561914,485599,786181,1046514,511716,391142,814817,626511,89638,671476,365973,19700,244305,836908,178349,294606,738622,123645,958047,119479,502957,731345,817513,407984,311088,458010,971772,596037,31534,279983,130533,737378,123857,77722,1011308,631299,426846,932654,92514,413341,328909,419250,133250,623116,560871,1037227,883688,501889,811644,968570,482466,852544,353285,965714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]