SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411683 LIMIT 1 [ RunTime:0.004939s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411683 [ RunTime:0.002573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71984,55581,932489,846065,757528,518809,104073,430121,37979,356181,927862,565486,461933,675031,722773,990385,739438,116064,813335,771197,599165,448631,164693,681813,713127,299726,431309,467336,409793,813646,970200,367378,638550,481301,849766,331866,486328,744383,588614,468329,891192,324973,376483,851904,46607,475590,662798,935692,136269,415373,710438,533159,247076,498993,302759,134104,273509,201731,992955,962716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]