SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003655s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682017 LIMIT 1 [ RunTime:0.003709s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682017 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362833,791902,311648,567449,255903,546316,673926,302448,17101,668879,64223,932825,981090,50729,437165,922435,404613,1028119,877931,838751,270396,160798,566388,92007,43546,941328,655819,555016,1039120,666225,207024,575556,673743,993138,370872,630524,408045,670477,757796,917667,428954,436762,692381,657568,666407,526927,467626,883603,1024177,47040,427304,602338,852441,374539,945170,72506,190824,228510,264440,887366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000759s ]