SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335116 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335116 [ RunTime:0.003633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269848,809494,518112,934242,752848,866861,701276,927606,754269,708684,851310,726037,813822,632806,230004,48873,160166,860544,871707,129972,898047,267335,864737,983077,877714,881630,170759,409690,98392,666299,13229,60193,816077,352207,825162,473660,570566,481402,1002737,445542,555368,678407,921849,895461,47817,652002,82077,989050,484425,454202,314280,273295,515195,200791,772968,17012,876008,877720,297009,666100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]