SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191818 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191818 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338981,1037533,157570,929999,818195,501186,413609,1026157,907227,737050,235527,310899,770639,12982,597478,645336,383288,252063,344263,820449,683213,1013409,423735,102875,86113,150626,383615,58531,732987,311232,215623,203345,603051,844202,530660,859411,930461,176608,316088,446884,29405,126088,590942,1046460,277980,691789,27026,558299,580465,212557,342403,195337,810551,823240,368947,858705,68866,530536,916072,499588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]