SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570920 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570920 [ RunTime:0.002708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656391,157796,13754,158769,811065,571632,40613,275494,755862,138904,234305,774623,311898,184353,730354,1046544,404335,554638,173698,177945,253544,334357,328339,1047159,893387,987557,442126,795387,886468,85328,546880,786916,307429,785784,324279,1032841,575701,319371,382379,727384,786441,21684,1004530,658685,974360,36441,19920,988382,308937,11726,89581,150645,823918,543236,511425,126220,690990,194689,423640,486097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]