SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105085 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105085 [ RunTime:0.002410s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392717,850125,190638,131915,282037,720838,121358,126717,271818,10204,929883,885347,109550,833799,645589,927314,891584,813152,36580,99993,93317,338176,904431,920028,810208,634251,94390,543499,334242,310574,406954,627000,801660,593142,914177,517918,517100,147897,527717,170894,43853,551519,661453,170151,44135,734756,964682,364078,91456,215841,261128,138697,1047327,982601,126380,791935,688634,579493,277684,328595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]