SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505437 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505437 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678609,539918,645247,203650,718690,598256,476568,652171,162657,340976,332085,211684,955908,122857,376816,683299,659680,660303,416706,705958,564500,540350,718864,501957,487491,996139,528038,532133,84117,843598,354175,124510,946618,208492,398230,731377,83895,1038327,627547,452755,402754,278240,441931,566458,834767,928018,744335,837377,507405,850470,134301,594279,84900,98885,854460,248854,433224,806486,396288,339796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]