SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42118 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42118 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043071,464174,64472,464243,185467,630866,853725,602526,622108,1000622,960473,116804,814303,10035,848347,910868,5224,564530,146949,334946,16443,890083,419477,685436,9779,10452,581423,346025,192646,710937,729899,476291,1004338,560054,977854,419478,786228,307786,352278,128287,628516,371609,398449,971711,303850,835597,604205,287197,812751,475873,662866,964146,548317,1000048,462967,241488,869641,770453,918781,716259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001328s ]