SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002063s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525142 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525142 [ RunTime:0.007788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474973,784300,111783,535028,784007,1008086,134840,698005,1046378,791379,709390,1048686,183325,44018,823836,786146,699244,666501,682333,671025,783708,759187,74439,660358,991500,328720,1006239,675638,196877,113194,1047243,863845,1041608,260915,286148,1006371,275765,318897,371547,192492,227783,502037,651318,465818,1011258,368825,63409,805823,73614,879868,809585,646795,64544,410836,48265,264968,751831,649294,916762,866173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004849s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001004s ]