SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001023 LIMIT 1 [ RunTime:0.001408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001023 [ RunTime:0.007594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660558,833034,985144,7747,902555,925337,340640,756844,511408,959420,76521,556983,879159,1002430,192852,68741,314763,885481,318432,11782,60444,600896,353673,725703,151100,420416,210654,646790,984781,548490,424897,900046,671803,926675,144103,89173,491346,253585,781143,891479,658028,65861,862187,48800,543590,162846,1014116,538802,381992,793904,208982,387069,876750,151614,807292,592169,686401,689378,1028639,276549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002382s ]