SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412256 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412256 [ RunTime:0.002564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811110,337597,910681,813152,20110,656649,302030,436089,129122,209901,727797,769412,3118,813092,35804,613063,278908,700146,638858,239335,418484,348850,851398,354138,123688,990190,1005236,655153,294497,829883,901364,1045756,105145,126660,174720,584270,2153,918141,437998,360329,717555,976355,382979,180479,973325,251121,173628,16092,498851,1046634,589855,713177,176070,782315,529692,723913,699045,799052,325543,635354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412256 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412256 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]