SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594704 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594704 [ RunTime:0.003330s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426202,951912,332721,793375,733564,979203,535745,638028,186281,1027301,473424,414813,110133,319676,589874,595353,44064,162483,146593,250114,699054,764318,159407,921973,943640,937455,721237,318,334585,976012,419426,523073,170218,895525,440331,861869,479805,255565,1027125,988285,637395,981053,688923,651431,206978,83820,713537,662736,628095,219498,941231,674059,415038,323308,184602,385335,628240,222515,545700,270628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]