SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019800 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019800 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545391,950159,878446,817049,970759,998656,540619,540669,462109,244848,175046,974565,347268,284734,627433,210952,262868,764873,953496,367034,884610,193992,469319,143594,860904,176308,793902,448098,364217,653045,289355,219095,990642,136402,809150,130055,1031406,63818,832241,385635,775212,678522,603500,214895,567664,544061,411631,932922,736311,738236,348584,714023,625194,633173,1037075,819945,891768,669446,398381,102827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]