SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46300 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46300 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469961,619559,973988,239315,95920,628385,968938,1003604,963485,83013,129715,291867,679299,831911,683265,243874,460222,574817,608974,88685,357954,661332,721451,882331,283102,338990,481946,759080,956408,1026371,1016019,879741,773349,613182,231910,818691,886522,450401,227198,272229,826096,984353,241117,251176,65264,39251,105514,995709,1032798,238667,74008,462531,792630,242007,413814,732802,498894,23795,746964,671042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]