SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484072 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484072 [ RunTime:0.002592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548561,705315,293420,728132,165288,751420,17252,236898,546911,1036796,222997,519881,67474,574842,285615,530395,290019,602348,750854,285037,209703,383165,544116,770784,393899,168852,361747,116128,188515,696338,100370,178180,846419,193688,628964,214110,508035,302602,298031,258701,409847,440227,298642,600787,139163,929718,470076,128217,452440,601558,527769,160791,604439,346910,543590,503941,905393,645779,372488,506116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]