SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 176103 LIMIT 1 [ RunTime:0.002164s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 176103 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277006,176115,124080,318120,115456,575732,119243,1046139,461580,933945,757755,1048283,54618,318555,233066,1030513,184080,288289,396937,632135,282658,567485,818408,121207,561973,794154,111599,1020641,1040488,907586,402792,1039389,609084,433264,875595,701793,1027643,15579,904180,75852,285692,375652,209922,907162,252484,531140,312925,143659,367082,116493,210774,678308,55220,714744,549661,601775,364884,839888,491030,647161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 176103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 176103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]