SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52974 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52974 [ RunTime:0.002183s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414419,733586,368562,281389,690120,162987,478552,414013,829531,443207,932567,681110,30084,929479,319213,310491,533746,308616,662398,923060,221551,819443,565722,633379,864245,935878,598997,687582,431504,215006,355375,276030,911233,167100,382935,83820,341442,100706,395614,791690,345801,115989,335179,608883,104996,352706,992759,222958,860684,259601,586823,474820,720251,815742,849526,364579,382125,626531,442919,76345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001718s ]