SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550028 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550028 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728240,409791,609735,165797,324976,1028216,233687,669013,898017,666475,956242,713257,680962,896970,613693,331691,147041,435562,313688,956520,825347,546761,58968,709216,395936,452484,218536,902953,659492,301054,860308,987900,555528,55447,468592,217840,824557,336996,228212,723213,670069,79642,79583,789100,504451,643929,371522,942700,1047501,736408,368863,330868,501144,549331,417030,277297,800888,485031,453088,621885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]