SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453478 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453478 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643305,181980,377841,801212,737786,305291,383041,631615,847568,114775,827336,1004844,53749,957186,177416,821009,750869,710411,632082,647397,124799,515659,518979,374093,742517,973030,696305,510462,35607,598,473560,230246,478292,976418,485754,834815,151732,984957,170694,1044869,149007,1011575,920474,513601,697905,795067,30001,683737,182212,726448,499663,603364,250503,282772,502025,242639,46753,272809,977911,492278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]