SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001566s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598403 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598403 [ RunTime:0.002060s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42005,680283,343144,254316,196559,796146,835788,338398,319775,718834,247686,34667,418415,74400,115434,513989,608432,7429,603470,1016745,402182,490633,372885,459618,88620,580512,431289,809258,696196,280696,60059,128951,369702,412365,789029,323883,674292,716760,746228,619134,274107,256264,287861,1000370,58443,131021,9549,197353,311453,702549,545317,239645,260357,26277,138773,251951,67151,491309,478143,559366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]