SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267221 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267221 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017614,702813,278471,948185,473843,743515,492688,18394,922695,624873,602854,1016880,187870,679450,568888,304734,59905,820310,12398,609723,517327,936114,426857,43091,484653,475265,570976,882793,1032666,505614,945169,436742,639866,38754,300029,863366,327672,864807,183726,627206,966090,574978,339127,742323,882476,333451,195962,636261,518930,708562,580667,1009002,84252,407832,509812,36752,446790,573957,760498,6742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]