SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684072 LIMIT 1 [ RunTime:0.000905s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684072 [ RunTime:0.002944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017940,767442,550064,1001763,871563,333817,163582,135850,482334,705188,894919,425683,263827,182828,999115,374232,615344,921413,308416,680151,347389,326871,393050,907287,719505,456769,467573,690989,1032345,842866,18980,573795,725871,23140,887219,428071,589971,606398,449292,745698,935035,197525,309311,925634,695457,344587,50752,254149,121539,10533,95114,1024208,203764,334924,543699,597727,62871,598552,752364,260566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]