SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5571 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5571 [ RunTime:0.002590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668637,885068,341091,659376,803988,77358,511613,923124,444514,848408,490087,402675,476431,107332,265297,341687,407254,471421,254177,406901,739672,696644,268100,439063,771739,36344,479638,615960,192747,11165,421539,268998,1031973,1029810,580400,104290,618622,1024733,634713,204506,367294,429166,925973,308611,861980,628697,805211,206740,226608,34498,133044,335400,493164,571361,460178,1043835,455598,344392,230354,776279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]