SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414253 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414253 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362499,218746,909783,763514,263765,961768,256642,72639,403744,956089,230742,601762,241163,758391,494714,179331,640147,879299,992953,331000,717779,788128,870726,188243,961348,508811,1028926,454900,306292,551859,432002,262119,874151,963535,660336,633223,415464,426258,639717,243828,53227,406823,262111,689975,575612,403371,239514,482960,786126,97093,593914,385207,555160,326313,1032928,346516,212108,523117,275172,157678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]