SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200606 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200606 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113373,597448,730251,945291,279529,2466,719501,327036,126812,844410,423354,294231,245638,987588,187208,569443,838909,180148,416294,481437,278879,141390,991894,445942,23093,226363,784085,621335,199150,219576,276809,638542,321059,591112,305149,405943,362760,454138,728217,790446,514926,943379,138439,63729,1024412,729276,1012930,401524,354216,942576,717473,234144,407620,638985,708252,437553,307571,412074,979457,676125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200606 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200606 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]