SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047420 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047420 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (944648,728569,524303,718569,143988,136021,271848,680708,1036397,1027544,144599,83427,862657,671738,863366,911937,345588,575845,97578,875882,124066,881012,517803,253106,709407,203129,1032733,407503,125959,199046,216237,142528,523126,680390,141210,425683,338453,305395,675980,348855,225999,474738,357623,113737,51858,980034,35188,921808,903006,597914,962204,364325,188891,510750,738276,904246,381574,91435,386592,1021550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]