SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001628s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286540 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286540 [ RunTime:0.004689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444429,327184,41868,387480,229402,721874,395841,758980,940529,645256,765346,726141,619154,760833,352756,503772,856422,953776,375687,710691,750023,913004,781393,35495,845913,409269,184924,196601,1025577,283824,635071,517565,73220,301187,375250,552479,388908,532676,781190,796597,77257,246302,644180,238096,118393,193140,313152,196823,382732,709109,114618,738669,281853,119776,304991,355739,296472,219073,737899,169900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000882s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001203s ]