SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 113919 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 113919 [ RunTime:0.005176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417339,914456,9170,459959,653933,672740,305953,111812,656631,1007474,583444,811988,177106,97823,441060,899365,682561,385571,991626,632597,730360,419673,852015,688840,391440,330161,662470,682305,788944,344758,543474,345903,379278,718342,1016754,742017,603827,1013243,723609,230668,369007,650043,277423,605125,824416,814059,1667,31953,951335,31053,897316,905717,738962,371902,1004635,174216,89271,323461,573472,782983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 113919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 113919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002596s ]