SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56083 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56083 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476210,751070,1048572,384348,38757,30474,413144,78114,805131,781778,262226,403242,809182,317409,393435,213418,631318,30863,150430,59382,747798,501616,1038738,894300,705740,607496,741891,727490,176775,665522,909101,514939,864811,632646,147185,30317,246517,871719,244093,981864,373847,346006,606719,588860,608192,609439,566742,581806,471591,181275,919395,456660,867145,138189,379949,430413,134155,164659,78332,167271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]