SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508950 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508950 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178669,457551,1029989,500892,709812,1018271,1041836,179567,608643,973727,606509,1040072,707012,150807,938085,543676,644811,514809,980655,301254,395400,864040,186112,180110,992122,940712,683706,272747,1021194,964944,469481,829848,398246,824920,392589,822621,588407,872340,117978,69642,647040,690907,80394,189848,150642,105630,754275,672824,915074,442084,120933,395148,602679,936205,449965,5928,794705,115763,595139,639577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]