SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53416 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53416 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911732,383137,203274,684254,279003,997978,775126,965008,679685,395632,607569,870962,875291,1019818,496394,826270,758008,30312,306774,225802,432646,480315,974135,560666,868201,101094,163676,170609,669507,437218,776749,862703,843169,797294,249873,493572,635316,444871,237818,507360,972104,669704,298049,392881,589098,146921,25317,489575,850444,600069,856751,907811,1034286,724395,281592,918805,48593,1003718,876563,538897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000731s ]