SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41141 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41141 [ RunTime:0.002365s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146894,158118,584650,564628,442147,1014928,992101,972276,934499,635901,673387,17494,374730,584923,890978,46040,753775,1003687,587016,585003,54634,176902,1001799,784050,543764,264118,176100,919365,512537,1018028,534255,54103,144049,958071,208699,301619,697146,377844,369532,359574,669742,810210,559486,680425,798830,940685,534857,331614,330951,558133,655107,663393,405911,343971,146690,318712,537006,761244,896926,955075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]