SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112186 LIMIT 1 [ RunTime:0.005518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112186 [ RunTime:0.002340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517933,670995,258552,1018516,401400,504618,1035721,886400,815992,424608,686022,329951,934523,60119,997638,474283,571850,476435,23339,498387,848878,199675,217317,89409,43548,91122,380746,406623,523571,404667,810864,719987,866614,595277,519899,628059,436754,147933,870801,309472,415069,465643,628140,187695,1046312,543045,280459,355562,518559,779517,256082,905807,305110,984492,851907,991938,82015,33916,584860,36558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]