SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003457s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583511 LIMIT 1 [ RunTime:0.001241s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583511 [ RunTime:0.005948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353479,336820,729207,704311,232785,645892,955416,471041,97868,306245,840798,332752,718980,98657,103222,771818,622831,515608,109244,267587,1030398,207794,235677,832419,1020287,206224,832684,487086,399064,820331,725312,118717,117495,323624,27092,692503,816145,331597,150500,188521,150860,793213,280513,347850,498811,731055,1021691,529351,984941,351998,370847,1014448,529668,606043,45395,691546,494309,630394,679506,796319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001879s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001044s ]