SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410343 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410343 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129707,403153,360590,274247,579220,353777,930154,406273,69337,763043,110980,460622,612336,875610,528849,873391,224470,685591,631466,525357,911401,698439,285707,892720,871289,413024,149336,641205,87410,808117,1021138,746463,388917,467106,244275,617376,494269,834728,83435,171186,488088,385620,80838,816844,555918,68761,58679,671132,1012277,872449,577869,749119,396588,947762,452770,1038998,304188,627760,1042390,745869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]