SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594881 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594881 [ RunTime:0.003239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903414,537344,83547,609994,837876,438293,66744,57886,947589,842919,900628,204941,248836,920615,559451,148059,683493,75361,97198,775393,688901,938868,804255,266963,920086,985629,584776,405790,550197,857561,664819,972145,58034,248503,935041,9347,197738,32923,60083,27574,466911,949490,709589,27798,409962,43025,150705,613580,798843,443278,409071,387807,626812,304842,653560,616282,72469,661876,180306,566588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]