SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439715 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439715 [ RunTime:0.002087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417882,866308,619333,1037453,373389,446301,74966,280925,269470,810409,141345,941792,733319,284340,395241,833852,831716,770513,378753,42044,842995,214347,774311,238033,472413,683852,537378,582782,426730,983399,527979,573337,747082,704568,27921,21325,176518,50832,637720,143014,882103,902168,459460,644101,881972,17569,739146,263404,760084,245639,266126,61349,67544,839517,44589,788859,640112,206255,441636,724796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]