SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428140 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428140 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039942,842288,411777,649896,765288,315492,398946,178707,1043174,648993,725002,931202,436717,59510,729995,679269,286309,176399,590915,350892,854469,709315,786786,812452,491281,951468,618064,347635,261140,287063,105887,886875,699856,360896,712905,448068,662833,825129,1006270,609599,265105,193196,147689,322493,267232,1037176,869472,910391,45622,802050,869045,839956,294463,13594,151581,936633,930526,1012722,207491,700355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]