SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002493s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005778 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005778 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638917,33452,220555,301488,485018,60645,731597,518901,105681,678075,102605,527727,923471,554324,528753,485811,1046464,218137,797729,512424,795907,370331,907854,303427,7703,4606,468507,561054,717475,705840,187,327996,526562,404083,669495,100054,364503,451035,119303,178962,409561,909915,325076,651228,845587,432932,221411,99316,330582,62967,356807,126339,946218,182667,199917,135652,949673,61529,734636,432430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005778 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005778 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]