SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424047 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424047 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97897,44040,98770,520343,684439,71262,489965,74456,408051,398480,482685,601045,761606,465140,547529,140982,228415,584676,299241,559782,716389,176150,180677,459450,538406,169524,530121,783171,906859,24407,791052,970287,358379,396317,293948,445523,940985,904481,695446,678134,99254,831146,244224,315421,271295,950440,793919,235481,567495,763844,566489,67832,420908,528315,227223,776063,614671,407815,615737,634835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]