SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005282 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005282 [ RunTime:0.002162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278002,522038,989605,96683,1018761,34019,152004,147562,666113,560688,657038,267919,825217,288791,216815,731498,749342,1014096,371365,973274,308950,192218,707186,802404,516630,402562,854038,777434,999396,649242,497655,173140,936510,396124,6628,569466,784918,125324,408260,751365,497474,241592,878566,97744,118820,269434,621625,491993,811103,157950,985839,291923,221932,381986,512831,825733,88330,792589,490576,311561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005282 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005282 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]