SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515983 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515983 [ RunTime:0.002047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047951,297907,152113,546420,993514,42386,333209,849417,990338,70763,991903,301667,175246,419051,1009330,626040,846749,255639,585000,85787,394278,115250,229788,478489,56052,437323,21809,345091,579935,626907,983426,25428,11191,400159,377837,264451,104816,1026911,978317,550942,519215,84023,881599,58828,228284,576953,308931,852786,136921,1832,934754,206511,475247,28555,875978,528404,754480,438665,578374,379479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]