SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011148 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011148 [ RunTime:0.002182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879777,691277,87525,411283,480309,587605,925769,560555,327657,26725,658681,710626,556028,587729,230451,154763,122111,366890,37478,789541,517619,198933,738570,448044,277560,522490,232610,90225,966599,547632,113463,247326,3838,991615,778502,107628,579684,951896,721241,305435,186307,954350,617966,490240,424400,520094,851349,49135,559653,651245,438677,496328,682835,148734,442845,154107,816364,459337,688610,138063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]