SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38497 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38497 [ RunTime:0.002082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912672,975836,360889,900726,420004,854287,721914,880899,110951,682764,988700,483915,190161,555765,71223,1013677,513035,130736,21109,1033432,318462,811555,1047631,590134,324886,229289,408540,46437,249185,681685,474070,858436,819493,510327,344817,754492,761675,278912,157110,98182,359105,827424,9301,671693,460142,460600,316010,54152,301379,175804,464408,673994,328380,908447,208365,730963,684307,412640,482557,786699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38497 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38497 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]