SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003928s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039600 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039600 [ RunTime:0.003124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387414,198483,565560,13876,228879,827540,988415,780822,872409,758016,806977,725168,744199,666760,874181,934958,618622,831092,512852,4020,192058,496168,749732,421,351750,168231,846886,235952,685090,558707,192233,74603,943028,932924,854595,446859,167227,185714,104545,54299,880105,616899,240169,120644,805803,755297,1011174,735912,828951,426519,910641,316811,412976,678124,792093,482917,897072,407717,170035,711737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]