SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002056s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481210 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481210 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437758,355274,679654,191630,709539,831076,530699,818666,131692,224294,950052,846343,562034,449927,377488,716283,30192,908706,525109,737342,361121,683551,1018827,811854,193199,770962,1035702,862145,195700,123954,88674,624083,263228,197242,965533,640506,510945,354265,889421,121120,992615,690241,921175,1042483,780893,609802,68054,843727,548116,671883,40585,831158,94013,387770,910030,704074,280952,414052,213879,291507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]