SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 644993 LIMIT 1 [ RunTime:0.000526s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 644993 [ RunTime:0.002586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159927,964437,867743,869454,400765,67701,981987,760123,1004329,989292,67681,571389,592314,61025,660538,92641,688170,362010,879932,183775,422122,246914,610171,982256,743546,438180,107846,419150,343851,162621,717822,111196,869504,285425,138319,345528,756000,854661,675136,39981,478661,706025,334846,640080,709262,100336,676611,940553,234987,641591,340430,473450,238543,391788,738032,708162,733429,1007583,369083,969752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 644993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001723s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 644993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001466s ]