SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002796s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 120094 LIMIT 1 [ RunTime:0.001308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 120094 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040430,501169,727374,680824,861216,511558,59069,155008,138335,553465,116623,163645,1027439,721987,678458,583352,431330,865159,594127,158901,679669,969183,648565,531676,1040098,610999,618380,774424,909226,1006358,1024985,433277,149828,1026018,818271,513938,883330,727472,159823,613247,1032415,100377,260154,85213,919063,147687,955778,676077,206587,933742,487288,165054,311238,775798,622157,577482,318654,839069,865671,175283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 120094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 120094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000813s ]