SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396813 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396813 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439343,305665,245734,937437,515547,729412,776823,325974,548047,270537,936861,630112,628741,494246,158257,35481,394732,91942,441564,382979,562455,827131,128189,807946,181863,424569,516465,69193,106778,909407,1044813,799681,58949,154858,162064,902065,780576,461995,71900,6257,25813,580215,144797,426911,945166,135249,121153,936386,869728,289224,712631,836344,183622,158447,681572,585461,226196,567968,34043,705039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]