SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 137813 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 137813 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406286,195006,65670,22449,668886,402472,325983,808635,924535,443439,721189,62419,198107,274538,90922,1033652,672952,140427,360918,561836,317481,1026573,887358,441465,901722,893041,112687,698473,656811,323269,963594,229607,305775,865938,911571,500404,645126,462051,649264,494983,251422,386863,547345,432702,427757,988133,985367,709471,980622,465906,754501,493312,483261,1020938,737600,713811,414205,541892,316797,304847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 137813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 137813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]