SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802593 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802593 [ RunTime:0.003653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10474,279134,58058,105543,729553,369293,430052,945499,470335,68290,814844,296232,874982,785776,200261,219044,43805,540015,23259,843135,278914,696752,194871,1833,614162,135472,683689,444786,912144,11920,729035,468728,112443,849320,91799,923291,940255,579769,367382,494180,654632,195929,382107,263255,371553,84691,1008868,1020323,490125,101380,372099,678717,411423,359670,339283,750126,994530,634082,878680,369492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]