SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 952390 LIMIT 1 [ RunTime:0.000599s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 952390 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980727,881198,684912,351963,472606,260176,102008,506281,426738,526230,679050,172407,767078,651740,800486,155163,821952,63053,772749,164798,491764,1044903,630511,224009,238010,44466,369972,1029554,551631,297497,434394,885390,451654,103856,53773,841637,412628,771188,820253,527914,911499,1009957,171320,650724,309840,68339,690702,166652,718010,35426,767479,964486,138891,857357,223004,557984,388117,654041,799460,475848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 952390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 952390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000874s ]