SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 558976 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 558976 [ RunTime:0.002529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427783,494157,419224,938676,90449,133173,655280,483706,442695,587879,594155,975490,661749,650386,856377,558490,375140,1004272,814481,517784,570271,31287,833620,626139,859548,811007,26922,248265,928046,891538,410274,291266,26403,856693,929411,319329,506694,964217,638696,484962,418176,208587,446851,787581,537787,69467,942686,900169,208744,998000,301771,424336,323231,718783,553988,172568,556985,638331,413466,811395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 558976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 558976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]