SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003452s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262916 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262916 [ RunTime:0.002172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327503,707038,802881,404957,75391,1035532,566367,850966,581297,591725,366896,498646,449698,955490,474061,512325,1033171,12478,405752,486739,145294,440149,749564,552284,612125,699921,666296,285485,645462,213406,330962,602323,25564,708540,183224,366049,712818,856951,163195,733495,101500,779623,692153,579849,221135,827500,316254,570152,14016,1047303,999274,53826,692876,579564,60236,483553,678229,555753,491561,406177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]